Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

Table
1) A global temporary tables name begins with ##
2) A script that creates a global temporary table of random numbers
3) A script that uses a local temporary table instead of a derived table
4) A statement that adds a new check constraint
5) A statement that adds a new column
6) A statement that changes the data type of a column
7) A statement that creates a table with column attributes
8) A statement that drops a column
9) ALTER data size for a COLUMN
10) Alter table to add a constraint based on IN function
11) Alter table to add column
12) Alter table to drop a column
13) Altering a Table
14) Ambiguous column name during table join
15) Benchmarking the TRUNCATE and Delete
16) Change the length of the emp_name column in the employee table from varchar(30) to varchar(50)
17) Check table existance before dropping
18) CLUSTERED column
19) Column name with or without a table alias
20) Computational column
21) Computed columns are (by default) virtual columns not physically stored in the table
22) Create a computed column
23) Create a Table Index
24) Creating a Computed Column in alter table command
25) Creating a Local Temporary Table with a SELECT INTO
26) Creating a Table with Duplicate Rows
27) Designating a Columns Collation
28) Drop column syntax
29) Each declarative integrity constraint can be removed using the DROP clause of the ALTER TABLE statement
30) Expanded nvarchar(20) to nvarchar(300)
31) Local temporary Table
32) PRIMARY KEY column
33) Query two tables with column in common
34) Reference column with table name
35) Reporting Table Information
36) SELECT INTO a temporary table
37) Table alias during table join
38) Table Creation Script for Parent and Child with FOREIGN KEY Constraint and INSTEAD OF Trigger
39) Temporary Tables
40) The basic syntax of the ALTER TABLE statement
41) The basic syntax of the CREATE TABLE statement
42) The DROP COLUMN clause provides the ability to drop an existing column of the table
43) The syntax of the DROP TABLE statement
44) TRUNCATE TABLE removes all of the records in a table without logging a transaction
45) Use ALTER TABLE statement to define the foreign key of a table
46) Use ALTER TABLE statement to define the primary key
47) Using a Temporary Table to Communicate with an EXEC()